The Query Options include Choose language, which governs the language of the mode's metadata and query results in a specific Discover report. This allows customers to show the same report in multiple languages - appropriate for each user on the system. This setting will drive the report and its subsequent usage in the platform.
Changing Languages
To change languages on a relevant data model, use the Choose language drop-down to pick from several choices - that are heuristically driven based on the technology and the original cube's own settings and options (see below). In the event a language is not shown, the user can click More... to see a full listing of all languages. If the language is supported, the results will change to that language, otherwise, the default is returned.
Heuristic Language Options
When you open the underlying cube or model, the selected language option applies:
- Default: Returns the metadata and queries using the model's default language as defined in the data source.
- Application Language: Returns the metadata and queries using the language that Pyramid is using. That is, it attempts to load the model in the current user's preferred language. If the language does not exist, the underlying technologies may return the default language or may throw an error (SAP BW only).
- <Language Name>: Returns the metadata and queries in the explicitly selected language. Pyramid can read the other languages supported in the model's definition. These are listed here so the user can easily swap to a supported language.
- More ...: Open the More dialog to choose a supported language that is not available from the <Language Name> list.
User Defaults
The default language choice from the heuristic options can be driven from the user defaults capability in the admin console, the user's personal default settings, or both. In user defaults, the user can select the default or application options as described above.